package com.huangpuweb.task.model;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;

public class HpPersonHouseStatisticsRowMapper implements RowMapper<HpPersonHouseStatistics> {
    @Override
    public HpPersonHouseStatistics mapRow(ResultSet resultSet, int i) throws SQLException {
        HpPersonHouseStatistics hp = new HpPersonHouseStatistics();
        hp.setId(resultSet.getInt("id"));
        hp.setMc(resultSet.getString("mc"));
        hp.setSz(resultSet.getInt("sz"));
        hp.setLy(resultSet.getString("ly"));
        hp.setJd(resultSet.getString("jd"));
        hp.setCjrq(resultSet.getString("cjrq"));
        hp.setData_operatedate(resultSet.getTimestamp("data_operatedate"));
        hp.setData_operatetype(resultSet.getString("data_operatetype"));
        hp.setService_dt(resultSet.getString("service_dt"));
        hp.setData_src(resultSet.getString("data_src"));
        hp.setSys_load_dt(resultSet.getTimestamp("sys_load_dt"));
        hp.setIs_reload(resultSet.getString("is_reload"));
        hp.setSys_reload_dt(resultSet.getString("sys_reload_dt"));
        hp.setDate_id(resultSet.getString("date_id"));
        return hp;
    }
}
